Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 10866 |
| Missing cells | 13434 |
| Missing cells (%) | 5.9% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 1.7 MiB |
| Average record size in memory | 168.0 B |
Variable types
| CAT | 11 |
|---|---|
| NUM | 10 |
Reproduction
| Analysis started | 2020-06-18 07:22:32.645942 |
|---|---|
| Analysis finished | 2020-06-18 07:22:46.440910 |
| Duration | 13.79 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
imdb_id has a high cardinality: 10855 distinct values | High cardinality |
original_title has a high cardinality: 10571 distinct values | High cardinality |
cast has a high cardinality: 10719 distinct values | High cardinality |
homepage has a high cardinality: 2896 distinct values | High cardinality |
director has a high cardinality: 5067 distinct values | High cardinality |
tagline has a high cardinality: 7997 distinct values | High cardinality |
keywords has a high cardinality: 8804 distinct values | High cardinality |
overview has a high cardinality: 10847 distinct values | High cardinality |
genres has a high cardinality: 2039 distinct values | High cardinality |
production_companies has a high cardinality: 7445 distinct values | High cardinality |
release_date has a high cardinality: 5909 distinct values | High cardinality |
budget_adj is highly correlated with budget | High correlation |
budget is highly correlated with budget_adj | High correlation |
revenue_adj is highly correlated with revenue | High correlation |
revenue is highly correlated with revenue_adj | High correlation |
homepage has 7930 (73.0%) missing values | Missing |
tagline has 2824 (26.0%) missing values | Missing |
keywords has 1493 (13.7%) missing values | Missing |
production_companies has 1030 (9.5%) missing values | Missing |
imdb_id is uniformly distributed | Uniform |
original_title is uniformly distributed | Uniform |
cast is uniformly distributed | Uniform |
homepage is uniformly distributed | Uniform |
tagline is uniformly distributed | Uniform |
overview is uniformly distributed | Uniform |
budget has 5696 (52.4%) zeros | Zeros |
revenue has 6016 (55.4%) zeros | Zeros |
budget_adj has 5696 (52.4%) zeros | Zeros |
revenue_adj has 6016 (55.4%) zeros | Zeros |
id
Real number (ℝ≥0)
| Distinct count | 10865 |
|---|---|
| Unique (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66064.17743419841 |
|---|---|
| Minimum | 5 |
| Maximum | 417859 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 1221 |
| Q1 | 10596.25 |
| median | 20669 |
| Q3 | 75610 |
| 95-th percentile | 288556 |
| Maximum | 417859 |
| Range | 417854 |
| Interquartile range (IQR) | 65013.75 |
Descriptive statistics
| Standard deviation | 92130.13656 |
|---|---|
| Coefficient of variation (CV) | 1.394555115 |
| Kurtosis | 1.781869015 |
| Mean | 66064.17743 |
| Median Absolute Deviation (MAD) | 15121.5 |
| Skewness | 1.732293939 |
| Sum | 717853352 |
| Variance | 8487962063 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 42194 | 2 | < 0.1% | |
| 2047 | 1 | < 0.1% | |
| 251232 | 1 | < 0.1% | |
| 19819 | 1 | < 0.1% | |
| 279914 | 1 | < 0.1% | |
| 61872 | 1 | < 0.1% | |
| 271718 | 1 | < 0.1% | |
| 13668 | 1 | < 0.1% | |
| 101731 | 1 | < 0.1% | |
| 1378 | 1 | < 0.1% | |
| Other values (10855) | 10855 | 99.9% |
| Value | Count | Frequency (%) | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 417859 | 1 | < 0.1% | |
| 414419 | 1 | < 0.1% | |
| 409696 | 1 | < 0.1% | |
| 395883 | 1 | < 0.1% | |
| 395560 | 1 | < 0.1% |
| Distinct count | 10855 |
|---|---|
| Unique (%) | > 99.9% |
| Missing | 10 |
| Missing (%) | 0.1% |
| Memory size | 84.9 KiB |
| tt0411951 | 2 |
|---|---|
| tt0110729 | 1 |
| tt0342272 | 1 |
| tt1753968 | 1 |
| tt0095904 | 1 |
| Other values (10850) |
| Value | Count | Frequency (%) | |
| tt0411951 | 2 | < 0.1% | |
| tt0110729 | 1 | < 0.1% | |
| tt0342272 | 1 | < 0.1% | |
| tt1753968 | 1 | < 0.1% | |
| tt0095904 | 1 | < 0.1% | |
| tt0100813 | 1 | < 0.1% | |
| tt0383222 | 1 | < 0.1% | |
| tt0059319 | 1 | < 0.1% | |
| tt1477076 | 1 | < 0.1% | |
| tt3481550 | 1 | < 0.1% | |
| Other values (10845) | 10845 | 99.8% | |
| (Missing) | 10 | 0.1% |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.994478189 |
| Min length | 3 |
popularity
Real number (ℝ≥0)
| Distinct count | 10814 |
|---|---|
| Unique (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6464409519602429 |
|---|---|
| Minimum | 6.500000000000001e-05 |
| Maximum | 32.985763 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 6.5e-05 |
|---|---|
| 5-th percentile | 0.06425225 |
| Q1 | 0.20758275 |
| median | 0.3838555 |
| Q3 | 0.713817 |
| 95-th percentile | 2.04660175 |
| Maximum | 32.985763 |
| Range | 32.985698 |
| Interquartile range (IQR) | 0.50623425 |
Descriptive statistics
| Standard deviation | 1.000184934 |
|---|---|
| Coefficient of variation (CV) | 1.54721778 |
| Kurtosis | 210.9981321 |
| Mean | 0.646440952 |
| Median Absolute Deviation (MAD) | 0.2153785 |
| Skewness | 9.876331256 |
| Sum | 7024.227384 |
| Variance | 1.000369903 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0.109305 | 2 | < 0.1% | |
| 0.114027 | 2 | < 0.1% | |
| 0.126182 | 2 | < 0.1% | |
| 0.247926 | 2 | < 0.1% | |
| 0.410235 | 2 | < 0.1% | |
| 0.122543 | 2 | < 0.1% | |
| 0.358694 | 2 | < 0.1% | |
| 0.155519 | 2 | < 0.1% | |
| 0.984256 | 2 | < 0.1% | |
| 0.468552 | 2 | < 0.1% | |
| Other values (10804) | 10846 | 99.8% |
| Value | Count | Frequency (%) | |
| 6.5e-05 | 1 | < 0.1% | |
| 0.000188 | 1 | < 0.1% | |
| 0.00062 | 1 | < 0.1% | |
| 0.000973 | 1 | < 0.1% | |
| 0.001115 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 32.985763 | 1 | < 0.1% | |
| 28.419936 | 1 | < 0.1% | |
| 24.949134 | 1 | < 0.1% | |
| 14.311205 | 1 | < 0.1% | |
| 13.112507 | 1 | < 0.1% |
| Distinct count | 557 |
|---|---|
| Unique (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14625701.09414688 |
|---|---|
| Minimum | 0 |
| Maximum | 425000000 |
| Zeros | 5696 |
| Zeros (%) | 52.4% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 15000000 |
| 95-th percentile | 75000000 |
| Maximum | 425000000 |
| Range | 425000000 |
| Interquartile range (IQR) | 15000000 |
Descriptive statistics
| Standard deviation | 30913213.83 |
|---|---|
| Coefficient of variation (CV) | 2.1136227 |
| Kurtosis | 19.26943617 |
| Mean | 14625701.09 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.717237057 |
| Sum | 1.589228681e+11 |
| Variance | 9.556267894e+14 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 5696 | 52.4% | |
| 20000000 | 190 | 1.7% | |
| 15000000 | 183 | 1.7% | |
| 25000000 | 178 | 1.6% | |
| 10000000 | 176 | 1.6% | |
| 30000000 | 165 | 1.5% | |
| 5000000 | 141 | 1.3% | |
| 40000000 | 134 | 1.2% | |
| 35000000 | 128 | 1.2% | |
| 12000000 | 120 | 1.1% | |
| Other values (547) | 3755 | 34.6% |
| Value | Count | Frequency (%) | |
| 0 | 5696 | 52.4% | |
| 1 | 4 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 425000000 | 1 | < 0.1% | |
| 380000000 | 1 | < 0.1% | |
| 300000000 | 1 | < 0.1% | |
| 280000000 | 1 | < 0.1% | |
| 270000000 | 1 | < 0.1% |
| Distinct count | 4702 |
|---|---|
| Unique (%) | 43.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39823319.79339223 |
|---|---|
| Minimum | 0 |
| Maximum | 2781505847 |
| Zeros | 6016 |
| Zeros (%) | 55.4% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 24000000 |
| 95-th percentile | 213672164.5 |
| Maximum | 2781505847 |
| Range | 2781505847 |
| Interquartile range (IQR) | 24000000 |
Descriptive statistics
| Standard deviation | 117003486.6 |
|---|---|
| Coefficient of variation (CV) | 2.938064611 |
| Kurtosis | 73.16848928 |
| Mean | 39823319.79 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.658397231 |
| Sum | 4.327201929e+11 |
| Variance | 1.368981587e+16 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 6016 | 55.4% | |
| 12000000 | 10 | 0.1% | |
| 10000000 | 8 | 0.1% | |
| 11000000 | 7 | 0.1% | |
| 6000000 | 6 | 0.1% | |
| 5000000 | 6 | 0.1% | |
| 2000000 | 6 | 0.1% | |
| 13000000 | 5 | < 0.1% | |
| 20000000 | 5 | < 0.1% | |
| 14000000 | 5 | < 0.1% | |
| Other values (4692) | 4792 | 44.1% |
| Value | Count | Frequency (%) | |
| 0 | 6016 | 55.4% | |
| 2 | 2 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 6 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2781505847 | 1 | < 0.1% | |
| 2068178225 | 1 | < 0.1% | |
| 1845034188 | 1 | < 0.1% | |
| 1519557910 | 1 | < 0.1% | |
| 1513528810 | 1 | < 0.1% |
| Distinct count | 10571 |
|---|---|
| Unique (%) | 97.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 84.9 KiB |
| Hamlet | 4 |
|---|---|
| Alice in Wonderland | 3 |
| Shelter | 3 |
| Beauty and the Beast | 3 |
| Hercules | 3 |
| Other values (10566) |
| Value | Count | Frequency (%) | |
| Hamlet | 4 | < 0.1% | |
| Alice in Wonderland | 3 | < 0.1% | |
| Shelter | 3 | < 0.1% | |
| Beauty and the Beast | 3 | < 0.1% | |
| Hercules | 3 | < 0.1% | |
| The Black Hole | 3 | < 0.1% | |
| Life | 3 | < 0.1% | |
| Emma | 3 | < 0.1% | |
| Julia | 3 | < 0.1% | |
| Frankenstein | 3 | < 0.1% | |
| Other values (10561) | 10835 | 99.7% |
Length
| Max length | 104 |
|---|---|
| Median length | 14 |
| Mean length | 16.00220872 |
| Min length | 1 |
| Distinct count | 10719 |
|---|---|
| Unique (%) | 99.3% |
| Missing | 76 |
| Missing (%) | 0.7% |
| Memory size | 84.9 KiB |
| Louis C.K. | 6 |
|---|---|
| William Shatner|Leonard Nimoy|DeForest Kelley|James Doohan|George Takei | 5 |
| Bill Burr | 4 |
| Jennifer Lawrence|Josh Hutcherson|Liam Hemsworth|Woody Harrelson|Elizabeth Banks | 3 |
| Pierre Coffin | 3 |
| Other values (10714) |
| Value | Count | Frequency (%) | |
| Louis C.K. | 6 | 0.1% | |
| William Shatner|Leonard Nimoy|DeForest Kelley|James Doohan|George Takei | 5 | < 0.1% | |
| Bill Burr | 4 | < 0.1% | |
| Jennifer Lawrence|Josh Hutcherson|Liam Hemsworth|Woody Harrelson|Elizabeth Banks | 3 | < 0.1% | |
| Pierre Coffin | 3 | < 0.1% | |
| Chris Wedge | 3 | < 0.1% | |
| Elijah Wood|Ian McKellen|Viggo Mortensen|Liv Tyler|Orlando Bloom | 3 | < 0.1% | |
| Sylvester Stallone|Talia Shire|Burt Young|Carl Weathers|Burgess Meredith | 3 | < 0.1% | |
| Aziz Ansari | 3 | < 0.1% | |
| Zac Efron|Vanessa Hudgens|Ashley Tisdale|Lucas Grabeel|Corbin Bleu | 3 | < 0.1% | |
| Other values (10709) | 10754 | 99.0% | |
| (Missing) | 76 | 0.7% |
Length
| Max length | 110 |
|---|---|
| Median length | 69 |
| Mean length | 67.41882938 |
| Min length | 3 |
| Distinct count | 2896 |
|---|---|
| Unique (%) | 98.6% |
| Missing | 7930 |
| Missing (%) | 73.0% |
| Memory size | 84.9 KiB |
| http://www.thehungergames.movie/ | 4 |
|---|---|
| http://www.missionimpossible.com/ | 4 |
| http://phantasm.com | 4 |
| http://www.thehobbit.com/ | 3 |
| http://www.americanreunionmovie.com/ | 3 |
| Other values (2891) |
| Value | Count | Frequency (%) | |
| http://www.thehungergames.movie/ | 4 | < 0.1% | |
| http://www.missionimpossible.com/ | 4 | < 0.1% | |
| http://phantasm.com | 4 | < 0.1% | |
| http://www.thehobbit.com/ | 3 | < 0.1% | |
| http://www.americanreunionmovie.com/ | 3 | < 0.1% | |
| http://www.jeffdunham.com | 3 | < 0.1% | |
| http://www.transformersmovie.com/ | 3 | < 0.1% | |
| http://www.georgecarlin.com | 3 | < 0.1% | |
| http://www.kungfupanda.com/ | 3 | < 0.1% | |
| http://www.beowulfmovie.com/ | 2 | < 0.1% | |
| Other values (2886) | 2904 | 26.7% | |
| (Missing) | 7930 | 73.0% |
Length
| Max length | 242 |
|---|---|
| Median length | 3 |
| Mean length | 12.22630223 |
| Min length | 3 |
| Distinct count | 5067 |
|---|---|
| Unique (%) | 46.8% |
| Missing | 44 |
| Missing (%) | 0.4% |
| Memory size | 84.9 KiB |
| Woody Allen | 45 |
|---|---|
| Clint Eastwood | 34 |
| Steven Spielberg | 29 |
| Martin Scorsese | 29 |
| Ridley Scott | 23 |
| Other values (5062) |
| Value | Count | Frequency (%) | |
| Woody Allen | 45 | 0.4% | |
| Clint Eastwood | 34 | 0.3% | |
| Steven Spielberg | 29 | 0.3% | |
| Martin Scorsese | 29 | 0.3% | |
| Ridley Scott | 23 | 0.2% | |
| Ron Howard | 22 | 0.2% | |
| Steven Soderbergh | 22 | 0.2% | |
| Joel Schumacher | 21 | 0.2% | |
| Brian De Palma | 20 | 0.2% | |
| Tim Burton | 19 | 0.2% | |
| Other values (5057) | 10558 | 97.2% | |
| (Missing) | 44 | 0.4% |
Length
| Max length | 533 |
|---|---|
| Median length | 13 |
| Mean length | 14.51131971 |
| Min length | 2 |
| Distinct count | 7997 |
|---|---|
| Unique (%) | 99.4% |
| Missing | 2824 |
| Missing (%) | 26.0% |
| Memory size | 84.9 KiB |
| Based on a true story. | 5 |
|---|---|
| Be careful what you wish for. | 3 |
| Two Films. One Love. | 3 |
| You never forget your first love. | 2 |
| A Love Story | 2 |
| Other values (7992) |
| Value | Count | Frequency (%) | |
| Based on a true story. | 5 | < 0.1% | |
| Be careful what you wish for. | 3 | < 0.1% | |
| Two Films. One Love. | 3 | < 0.1% | |
| You never forget your first love. | 2 | < 0.1% | |
| A Love Story | 2 | < 0.1% | |
| Forget About Love | 2 | < 0.1% | |
| - | 2 | < 0.1% | |
| The chase is on! | 2 | < 0.1% | |
| Worlds Collide | 2 | < 0.1% | |
| One ordinary couple. One little white lie. | 2 | < 0.1% | |
| Other values (7987) | 8017 | 73.8% | |
| (Missing) | 2824 | 26.0% |
Length
| Max length | 286 |
|---|---|
| Median length | 30 |
| Mean length | 33.47349531 |
| Min length | 1 |
| Distinct count | 8804 |
|---|---|
| Unique (%) | 93.9% |
| Missing | 1493 |
| Missing (%) | 13.7% |
| Memory size | 84.9 KiB |
| woman director | 134 |
|---|---|
| independent film | 82 |
| sport | 25 |
| musical | 24 |
| duringcreditsstinger | 24 |
| Other values (8799) |
| Value | Count | Frequency (%) | |
| woman director | 134 | 1.2% | |
| independent film | 82 | 0.8% | |
| sport | 25 | 0.2% | |
| musical | 24 | 0.2% | |
| duringcreditsstinger | 24 | 0.2% | |
| suspense | 24 | 0.2% | |
| holiday | 16 | 0.1% | |
| stand-up|stand up comedy | 16 | 0.1% | |
| biography | 15 | 0.1% | |
| independent film|woman director | 13 | 0.1% | |
| Other values (8794) | 9000 | 82.8% | |
| (Missing) | 1493 | 13.7% |
Length
| Max length | 131 |
|---|---|
| Median length | 40 |
| Mean length | 36.61761458 |
| Min length | 2 |
| Distinct count | 10847 |
|---|---|
| Unique (%) | 99.9% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 84.9 KiB |
| No overview found. | 13 |
|---|---|
| Wilbur the pig is scared of the end of the season, because he knows that come that time, he will end up on the dinner table. He hatches a plan with Charlotte, a spider that lives in his pen, to ensure that this will never happen. | 2 |
| 1960. The thrilling battles waged by a band of kids from two rival villages in the southern French countryside. | 2 |
| In the year of 2039, after World Wars destroy much of the civilization as we know it, territories are no longer run by governments, but by corporations; the mightiest of which is the Mishima Zaibatsu. In order to placate the seething masses of this dystopia, Mishima sponsors Tekken, a tournament in which fighters battle until only one is left standing. | 2 |
| As the English and French soldiers battle for control of the North American colonies in the 18th century, the settlers and native Americans are forced to take sides. Cora and her sister Alice unwittingly walk into trouble but are saved by Hawkeye, an orphaned settler adopted by the last of the Mohicans. | 1 |
| Other values (10842) |
| Value | Count | Frequency (%) | |
| No overview found. | 13 | 0.1% | |
| Wilbur the pig is scared of the end of the season, because he knows that come that time, he will end up on the dinner table. He hatches a plan with Charlotte, a spider that lives in his pen, to ensure that this will never happen. | 2 | < 0.1% | |
| 1960. The thrilling battles waged by a band of kids from two rival villages in the southern French countryside. | 2 | < 0.1% | |
| In the year of 2039, after World Wars destroy much of the civilization as we know it, territories are no longer run by governments, but by corporations; the mightiest of which is the Mishima Zaibatsu. In order to placate the seething masses of this dystopia, Mishima sponsors Tekken, a tournament in which fighters battle until only one is left standing. | 2 | < 0.1% | |
| As the English and French soldiers battle for control of the North American colonies in the 18th century, the settlers and native Americans are forced to take sides. Cora and her sister Alice unwittingly walk into trouble but are saved by Hawkeye, an orphaned settler adopted by the last of the Mohicans. | 1 | < 0.1% | |
| In a quiet suburban town in the summer of 1958, two recently orphaned sisters are placed in the care of their mentally unstable Aunt Ruth. But Ruth's depraved sense of discipline will soon lead to unspeakable acts of abuse and torture that involve her young sons, the neighborhood children, and one 12-year-old boy whose life will be changed forever. | 1 | < 0.1% | |
| The story throws Elvis impersonators, Indians, modern cowboys, a 6-foot-tall blond assassin, a frat boy, a corrupt sheriff and a prostitute into a chase for a priceless American Indian artifact stolen during a poker game at an Indian casino | 1 | < 0.1% | |
| Hick handymen Val McKee and Earl Bassett can barely eke out a living in the Nevada hamlet of Perfection, so they decide to leave town -- despite an admonition from a shapely seismology coed who's picking up odd readings on her equipment. Before long, Val and Earl discover what's responsible for those readings: 30-foot-long carnivorous worms with a proclivity for sucking their prey underground. | 1 | < 0.1% | |
| A U.S. satellite crash-lands near a small town in Utah, unleashing a deadly plague that kills virtually everyone except two survivors, who may provide clues to immunizing the population. As the military attempts to quarantine the area, a team of highly specialized scientists is assembled to find a cure and stop the spread of the alien pathogen, code-named Andromeda. | 1 | < 0.1% | |
| Willy the whale is back, this time threatened by illegal whalers making money off sushi. Jesse, now 16, has taken a job on an orca-researching ship, along with old friend Randolph and a sarcastic scientist, Drew. On the whaler's ship is captain John Wesley and his son, Max, who isn't really pleased about his father's job, but doesn't have the gut to say so. Along the way, Willy reunites with Jesse | 1 | < 0.1% | |
| Other values (10837) | 10837 | 99.7% | |
| (Missing) | 4 | < 0.1% |
Length
| Max length | 1000 |
|---|---|
| Median length | 282 |
| Mean length | 306.9256396 |
| Min length | 3 |
runtime
Real number (ℝ≥0)
| Distinct count | 247 |
|---|---|
| Unique (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.07086324314375 |
|---|---|
| Minimum | 0 |
| Maximum | 900 |
| Zeros | 31 |
| Zeros (%) | 0.3% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 75 |
| Q1 | 90 |
| median | 99 |
| Q3 | 111 |
| 95-th percentile | 139 |
| Maximum | 900 |
| Range | 900 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 31.38140508 |
|---|---|
| Coefficient of variation (CV) | 0.307447239 |
| Kurtosis | 116.2375673 |
| Mean | 102.0708632 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 6.103792811 |
| Sum | 1109102 |
| Variance | 984.7925849 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 90 | 547 | 5.0% | |
| 95 | 358 | 3.3% | |
| 100 | 335 | 3.1% | |
| 93 | 328 | 3.0% | |
| 97 | 306 | 2.8% | |
| 96 | 300 | 2.8% | |
| 91 | 297 | 2.7% | |
| 94 | 292 | 2.7% | |
| 92 | 270 | 2.5% | |
| 98 | 270 | 2.5% | |
| Other values (237) | 7563 | 69.6% |
| Value | Count | Frequency (%) | |
| 0 | 31 | 0.3% | |
| 2 | 5 | < 0.1% | |
| 3 | 11 | 0.1% | |
| 4 | 17 | 0.2% | |
| 5 | 17 | 0.2% |
| Value | Count | Frequency (%) | |
| 900 | 1 | < 0.1% | |
| 877 | 1 | < 0.1% | |
| 705 | 1 | < 0.1% | |
| 566 | 1 | < 0.1% | |
| 561 | 1 | < 0.1% |
| Distinct count | 2039 |
|---|---|
| Unique (%) | 18.8% |
| Missing | 23 |
| Missing (%) | 0.2% |
| Memory size | 84.9 KiB |
| Comedy | 712 |
|---|---|
| Drama | 712 |
| Documentary | 312 |
| Drama|Romance | 289 |
| Comedy|Drama | 280 |
| Other values (2034) |
| Value | Count | Frequency (%) | |
| Comedy | 712 | 6.6% | |
| Drama | 712 | 6.6% | |
| Documentary | 312 | 2.9% | |
| Drama|Romance | 289 | 2.7% | |
| Comedy|Drama | 280 | 2.6% | |
| Comedy|Romance | 268 | 2.5% | |
| Horror|Thriller | 259 | 2.4% | |
| Horror | 253 | 2.3% | |
| Comedy|Drama|Romance | 222 | 2.0% | |
| Drama|Thriller | 138 | 1.3% | |
| Other values (2029) | 7398 | 68.1% |
Length
| Max length | 51 |
|---|---|
| Median length | 17 |
| Mean length | 18.50423339 |
| Min length | 3 |
| Distinct count | 7445 |
|---|---|
| Unique (%) | 75.7% |
| Missing | 1030 |
| Missing (%) | 9.5% |
| Memory size | 84.9 KiB |
| Paramount Pictures | 156 |
|---|---|
| Universal Pictures | 133 |
| Warner Bros. | 84 |
| Walt Disney Pictures | 76 |
| Columbia Pictures | 72 |
| Other values (7440) |
| Value | Count | Frequency (%) | |
| Paramount Pictures | 156 | 1.4% | |
| Universal Pictures | 133 | 1.2% | |
| Warner Bros. | 84 | 0.8% | |
| Walt Disney Pictures | 76 | 0.7% | |
| Columbia Pictures | 72 | 0.7% | |
| Metro-Goldwyn-Mayer (MGM) | 72 | 0.7% | |
| New Line Cinema | 61 | 0.6% | |
| Touchstone Pictures | 51 | 0.5% | |
| 20th Century Fox | 50 | 0.5% | |
| Twentieth Century Fox Film Corporation | 49 | 0.5% | |
| Other values (7435) | 9032 | 83.1% | |
| (Missing) | 1030 | 9.5% |
Length
| Max length | 184 |
|---|---|
| Median length | 36 |
| Mean length | 41.48601141 |
| Min length | 3 |
| Distinct count | 5909 |
|---|---|
| Unique (%) | 54.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 84.9 KiB |
| 1/1/09 | 28 |
|---|---|
| 1/1/08 | 21 |
| 1/1/07 | 18 |
| 1/1/05 | 16 |
| 10/10/14 | 15 |
| Other values (5904) |
| Value | Count | Frequency (%) | |
| 1/1/09 | 28 | 0.3% | |
| 1/1/08 | 21 | 0.2% | |
| 1/1/07 | 18 | 0.2% | |
| 1/1/05 | 16 | 0.1% | |
| 10/10/14 | 15 | 0.1% | |
| 1/1/06 | 13 | 0.1% | |
| 1/1/03 | 13 | 0.1% | |
| 9/7/12 | 13 | 0.1% | |
| 1/1/12 | 12 | 0.1% | |
| 10/16/15 | 12 | 0.1% | |
| Other values (5899) | 10705 | 98.5% |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.960058899 |
| Min length | 6 |
vote_count
Real number (ℝ≥0)
| Distinct count | 1289 |
|---|---|
| Unique (%) | 11.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 217.38974783729063 |
|---|---|
| Minimum | 10 |
| Maximum | 9767 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 17 |
| median | 38 |
| Q3 | 145.75 |
| 95-th percentile | 1025.75 |
| Maximum | 9767 |
| Range | 9757 |
| Interquartile range (IQR) | 128.75 |
Descriptive statistics
| Standard deviation | 575.6190577 |
|---|---|
| Coefficient of variation (CV) | 2.647866624 |
| Kurtosis | 53.36097878 |
| Mean | 217.3897478 |
| Median Absolute Deviation (MAD) | 26 |
| Skewness | 6.177305758 |
| Sum | 2362157 |
| Variance | 331337.2996 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10 | 501 | 4.6% | |
| 11 | 474 | 4.4% | |
| 12 | 422 | 3.9% | |
| 13 | 377 | 3.5% | |
| 14 | 323 | 3.0% | |
| 15 | 300 | 2.8% | |
| 16 | 270 | 2.5% | |
| 17 | 256 | 2.4% | |
| 18 | 218 | 2.0% | |
| 19 | 189 | 1.7% | |
| Other values (1279) | 7536 | 69.4% |
| Value | Count | Frequency (%) | |
| 10 | 501 | 4.6% | |
| 11 | 474 | 4.4% | |
| 12 | 422 | 3.9% | |
| 13 | 377 | 3.5% | |
| 14 | 323 | 3.0% |
| Value | Count | Frequency (%) | |
| 9767 | 1 | < 0.1% | |
| 8903 | 1 | < 0.1% | |
| 8458 | 1 | < 0.1% | |
| 8432 | 1 | < 0.1% | |
| 7375 | 1 | < 0.1% |
vote_average
Real number (ℝ≥0)
| Distinct count | 72 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.9749217743419845 |
|---|---|
| Minimum | 1.5 |
| Maximum | 9.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 1.5 |
|---|---|
| 5-th percentile | 4.4 |
| Q1 | 5.4 |
| median | 6 |
| Q3 | 6.6 |
| 95-th percentile | 7.4 |
| Maximum | 9.2 |
| Range | 7.7 |
| Interquartile range (IQR) | 1.2 |
Descriptive statistics
| Standard deviation | 0.9351418153 |
|---|---|
| Coefficient of variation (CV) | 0.1565111395 |
| Kurtosis | 0.5435032543 |
| Mean | 5.974921774 |
| Median Absolute Deviation (MAD) | 0.6 |
| Skewness | -0.4359079754 |
| Sum | 64923.5 |
| Variance | 0.8744902148 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 6.1 | 496 | 4.6% | |
| 6 | 495 | 4.6% | |
| 5.8 | 486 | 4.5% | |
| 5.9 | 473 | 4.4% | |
| 6.2 | 464 | 4.3% | |
| 6.3 | 461 | 4.2% | |
| 6.5 | 457 | 4.2% | |
| 6.4 | 446 | 4.1% | |
| 5.7 | 415 | 3.8% | |
| 6.6 | 413 | 3.8% | |
| Other values (62) | 6260 | 57.6% |
| Value | Count | Frequency (%) | |
| 1.5 | 2 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 2.1 | 3 | < 0.1% | |
| 2.2 | 3 | < 0.1% | |
| 2.3 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9.2 | 1 | < 0.1% | |
| 8.9 | 1 | < 0.1% | |
| 8.8 | 2 | < 0.1% | |
| 8.7 | 1 | < 0.1% | |
| 8.6 | 1 | < 0.1% |
release_year
Real number (ℝ≥0)
| Distinct count | 56 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2001.3226578317688 |
|---|---|
| Minimum | 1960 |
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 1960 |
|---|---|
| 5-th percentile | 1973 |
| Q1 | 1995 |
| median | 2006 |
| Q3 | 2011 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 55 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 12.81294057 |
|---|---|
| Coefficient of variation (CV) | 0.006402236302 |
| Kurtosis | 0.8000513183 |
| Mean | 2001.322658 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -1.204254294 |
| Sum | 21746372 |
| Variance | 164.1714461 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2014 | 700 | 6.4% | |
| 2013 | 659 | 6.1% | |
| 2015 | 629 | 5.8% | |
| 2012 | 588 | 5.4% | |
| 2011 | 540 | 5.0% | |
| 2009 | 533 | 4.9% | |
| 2008 | 496 | 4.6% | |
| 2010 | 490 | 4.5% | |
| 2007 | 438 | 4.0% | |
| 2006 | 408 | 3.8% | |
| Other values (46) | 5385 | 49.6% |
| Value | Count | Frequency (%) | |
| 1960 | 32 | 0.3% | |
| 1961 | 31 | 0.3% | |
| 1962 | 32 | 0.3% | |
| 1963 | 34 | 0.3% | |
| 1964 | 42 | 0.4% |
| Value | Count | Frequency (%) | |
| 2015 | 629 | 5.8% | |
| 2014 | 700 | 6.4% | |
| 2013 | 659 | 6.1% | |
| 2012 | 588 | 5.4% | |
| 2011 | 540 | 5.0% |
| Distinct count | 2614 |
|---|---|
| Unique (%) | 24.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17551039.82288678 |
|---|---|
| Minimum | 0.0 |
| Maximum | 425000000.0 |
| Zeros | 5696 |
| Zeros (%) | 52.4% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 20853251.08 |
| 95-th percentile | 89375137.94 |
| Maximum | 425000000 |
| Range | 425000000 |
| Interquartile range (IQR) | 20853251.08 |
Descriptive statistics
| Standard deviation | 34306155.72 |
|---|---|
| Coefficient of variation (CV) | 1.954650896 |
| Kurtosis | 13.03695179 |
| Mean | 17551039.82 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.114919907 |
| Sum | 1.907095987e+11 |
| Variance | 1.17691232e+15 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 5696 | 52.4% | |
| 10164004.34 | 17 | 0.2% | |
| 21033371.65 | 17 | 0.2% | |
| 20000000 | 16 | 0.1% | |
| 4605455.254 | 15 | 0.1% | |
| 33496898.69 | 14 | 0.1% | |
| 24234951.06 | 14 | 0.1% | |
| 20328008.68 | 13 | 0.1% | |
| 40656017.36 | 13 | 0.1% | |
| 26291714.57 | 13 | 0.1% | |
| Other values (2604) | 5038 | 46.4% |
| Value | Count | Frequency (%) | |
| 0 | 5696 | 52.4% | |
| 0.9210910508 | 1 | < 0.1% | |
| 0.9693980426 | 1 | < 0.1% | |
| 1.012786634 | 1 | < 0.1% | |
| 1.309052847 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 425000000 | 1 | < 0.1% | |
| 368371256.2 | 1 | < 0.1% | |
| 315500574.8 | 1 | < 0.1% | |
| 292050672.7 | 1 | < 0.1% | |
| 271692064.2 | 1 | < 0.1% |
| Distinct count | 4840 |
|---|---|
| Unique (%) | 44.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51364363.25325099 |
|---|---|
| Minimum | 0.0 |
| Maximum | 2827123750.41189 |
| Zeros | 6016 |
| Zeros (%) | 55.4% |
| Memory size | 84.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 33697095.72 |
| 95-th percentile | 276554439 |
| Maximum | 2827123750 |
| Range | 2827123750 |
| Interquartile range (IQR) | 33697095.72 |
Descriptive statistics
| Standard deviation | 144632485 |
|---|---|
| Coefficient of variation (CV) | 2.815813842 |
| Kurtosis | 63.37990799 |
| Mean | 51364363.25 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.251202093 |
| Sum | 5.581251711e+11 |
| Variance | 2.091855573e+16 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 6016 | 55.4% | |
| 14389144.83 | 2 | < 0.1% | |
| 57667591.03 | 2 | < 0.1% | |
| 1000000 | 2 | < 0.1% | |
| 209354710.5 | 2 | < 0.1% | |
| 29106404.28 | 2 | < 0.1% | |
| 81036423.44 | 2 | < 0.1% | |
| 967000 | 2 | < 0.1% | |
| 89906740.12 | 2 | < 0.1% | |
| 31721459 | 2 | < 0.1% | |
| Other values (4830) | 4832 | 44.5% |
| Value | Count | Frequency (%) | |
| 0 | 6016 | 55.4% | |
| 2.37070529 | 1 | < 0.1% | |
| 2.861933734 | 1 | < 0.1% | |
| 3.038359901 | 1 | < 0.1% | |
| 5.926763224 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2827123750 | 1 | < 0.1% | |
| 2789712242 | 1 | < 0.1% | |
| 2506405735 | 1 | < 0.1% | |
| 2167324901 | 1 | < 0.1% | |
| 1907005842 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| id | imdb_id | popularity | budget | revenue | original_title | cast | homepage | director | tagline | keywords | overview | runtime | genres | production_companies | release_date | vote_count | vote_average | release_year | budget_adj | revenue_adj | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 135397 | tt0369610 | 32.985763 | 150000000 | 1513528810 | Jurassic World | Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vincent D'Onofrio|Nick Robinson | http://www.jurassicworld.com/ | Colin Trevorrow | The park is open. | monster|dna|tyrannosaurus rex|velociraptor|island | Twenty-two years after the events of Jurassic Park, Isla Nublar now features a fully functioning dinosaur theme park, Jurassic World, as originally envisioned by John Hammond. | 124 | Action|Adventure|Science Fiction|Thriller | Universal Studios|Amblin Entertainment|Legendary Pictures|Fuji Television Network|Dentsu | 6/9/15 | 5562 | 6.5 | 2015 | 1.379999e+08 | 1.392446e+09 |
| 1 | 76341 | tt1392190 | 28.419936 | 150000000 | 378436354 | Mad Max: Fury Road | Tom Hardy|Charlize Theron|Hugh Keays-Byrne|Nicholas Hoult|Josh Helman | http://www.madmaxmovie.com/ | George Miller | What a Lovely Day. | future|chase|post-apocalyptic|dystopia|australia | An apocalyptic story set in the furthest reaches of our planet, in a stark desert landscape where humanity is broken, and most everyone is crazed fighting for the necessities of life. Within this world exist two rebels on the run who just might be able to restore order. There's Max, a man of action and a man of few words, who seeks peace of mind following the loss of his wife and child in the aftermath of the chaos. And Furiosa, a woman of action and a woman who believes her path to survival may be achieved if she can make it across the desert back to her childhood homeland. | 120 | Action|Adventure|Science Fiction|Thriller | Village Roadshow Pictures|Kennedy Miller Productions | 5/13/15 | 6185 | 7.1 | 2015 | 1.379999e+08 | 3.481613e+08 |
| 2 | 262500 | tt2908446 | 13.112507 | 110000000 | 295238201 | Insurgent | Shailene Woodley|Theo James|Kate Winslet|Ansel Elgort|Miles Teller | http://www.thedivergentseries.movie/#insurgent | Robert Schwentke | One Choice Can Destroy You | based on novel|revolution|dystopia|sequel|dystopic future | Beatrice Prior must confront her inner demons and continue her fight against a powerful alliance which threatens to tear her society apart. | 119 | Adventure|Science Fiction|Thriller | Summit Entertainment|Mandeville Films|Red Wagon Entertainment|NeoReel | 3/18/15 | 2480 | 6.3 | 2015 | 1.012000e+08 | 2.716190e+08 |
| 3 | 140607 | tt2488496 | 11.173104 | 200000000 | 2068178225 | Star Wars: The Force Awakens | Harrison Ford|Mark Hamill|Carrie Fisher|Adam Driver|Daisy Ridley | http://www.starwars.com/films/star-wars-episode-vii | J.J. Abrams | Every generation has a story. | android|spaceship|jedi|space opera|3d | Thirty years after defeating the Galactic Empire, Han Solo and his allies face a new threat from the evil Kylo Ren and his army of Stormtroopers. | 136 | Action|Adventure|Science Fiction|Fantasy | Lucasfilm|Truenorth Productions|Bad Robot | 12/15/15 | 5292 | 7.5 | 2015 | 1.839999e+08 | 1.902723e+09 |
| 4 | 168259 | tt2820852 | 9.335014 | 190000000 | 1506249360 | Furious 7 | Vin Diesel|Paul Walker|Jason Statham|Michelle Rodriguez|Dwayne Johnson | http://www.furious7.com/ | James Wan | Vengeance Hits Home | car race|speed|revenge|suspense|car | Deckard Shaw seeks revenge against Dominic Toretto and his family for his comatose brother. | 137 | Action|Crime|Thriller | Universal Pictures|Original Film|Media Rights Capital|Dentsu|One Race Films | 4/1/15 | 2947 | 7.3 | 2015 | 1.747999e+08 | 1.385749e+09 |
| 5 | 281957 | tt1663202 | 9.110700 | 135000000 | 532950503 | The Revenant | Leonardo DiCaprio|Tom Hardy|Will Poulter|Domhnall Gleeson|Paul Anderson | http://www.foxmovies.com/movies/the-revenant | Alejandro González Iñárritu | (n. One who has returned, as if from the dead.) | father-son relationship|rape|based on novel|mountains|winter | In the 1820s, a frontiersman, Hugh Glass, sets out on a path of vengeance against those who left him for dead after a bear mauling. | 156 | Western|Drama|Adventure|Thriller | Regency Enterprises|Appian Way|CatchPlay|Anonymous Content|New Regency Pictures | 12/25/15 | 3929 | 7.2 | 2015 | 1.241999e+08 | 4.903142e+08 |
| 6 | 87101 | tt1340138 | 8.654359 | 155000000 | 440603537 | Terminator Genisys | Arnold Schwarzenegger|Jason Clarke|Emilia Clarke|Jai Courtney|J.K. Simmons | http://www.terminatormovie.com/ | Alan Taylor | Reset the future | saving the world|artificial intelligence|cyborg|killer robot|future | The year is 2029. John Connor, leader of the resistance continues the war against the machines. At the Los Angeles offensive, John's fears of the unknown future begin to emerge when TECOM spies reveal a new plot by SkyNet that will attack him from both fronts; past and future, and will ultimately change warfare forever. | 125 | Science Fiction|Action|Thriller|Adventure | Paramount Pictures|Skydance Productions | 6/23/15 | 2598 | 5.8 | 2015 | 1.425999e+08 | 4.053551e+08 |
| 7 | 286217 | tt3659388 | 7.667400 | 108000000 | 595380321 | The Martian | Matt Damon|Jessica Chastain|Kristen Wiig|Jeff Daniels|Michael Peña | http://www.foxmovies.com/movies/the-martian | Ridley Scott | Bring Him Home | based on novel|mars|nasa|isolation|botanist | During a manned mission to Mars, Astronaut Mark Watney is presumed dead after a fierce storm and left behind by his crew. But Watney has survived and finds himself stranded and alone on the hostile planet. With only meager supplies, he must draw upon his ingenuity, wit and spirit to subsist and find a way to signal to Earth that he is alive. | 141 | Drama|Adventure|Science Fiction | Twentieth Century Fox Film Corporation|Scott Free Productions|Mid Atlantic Films|International Traders|TSG Entertainment | 9/30/15 | 4572 | 7.6 | 2015 | 9.935996e+07 | 5.477497e+08 |
| 8 | 211672 | tt2293640 | 7.404165 | 74000000 | 1156730962 | Minions | Sandra Bullock|Jon Hamm|Michael Keaton|Allison Janney|Steve Coogan | http://www.minionsmovie.com/ | Kyle Balda|Pierre Coffin | Before Gru, they had a history of bad bosses | assistant|aftercreditsstinger|duringcreditsstinger|evil mastermind|minions | Minions Stuart, Kevin and Bob are recruited by Scarlet Overkill, a super-villain who, alongside her inventor husband Herb, hatches a plot to take over the world. | 91 | Family|Animation|Adventure|Comedy | Universal Pictures|Illumination Entertainment | 6/17/15 | 2893 | 6.5 | 2015 | 6.807997e+07 | 1.064192e+09 |
| 9 | 150540 | tt2096673 | 6.326804 | 175000000 | 853708609 | Inside Out | Amy Poehler|Phyllis Smith|Richard Kind|Bill Hader|Lewis Black | http://movies.disney.com/inside-out | Pete Docter | Meet the little voices inside your head. | dream|cartoon|imaginary friend|animation|kid | Growing up can be a bumpy road, and it's no exception for Riley, who is uprooted from her Midwest life when her father starts a new job in San Francisco. Like all of us, Riley is guided by her emotions - Joy, Fear, Anger, Disgust and Sadness. The emotions live in Headquarters, the control center inside Riley's mind, where they help advise her through everyday life. As Riley and her emotions struggle to adjust to a new life in San Francisco, turmoil ensues in Headquarters. Although Joy, Riley's main and most important emotion, tries to keep things positive, the emotions conflict on how best to navigate a new city, house and school. | 94 | Comedy|Animation|Family | Walt Disney Pictures|Pixar Animation Studios|Walt Disney Studios Motion Pictures | 6/9/15 | 3935 | 8.0 | 2015 | 1.609999e+08 | 7.854116e+08 |
Last rows
| id | imdb_id | popularity | budget | revenue | original_title | cast | homepage | director | tagline | keywords | overview | runtime | genres | production_companies | release_date | vote_count | vote_average | release_year | budget_adj | revenue_adj | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10856 | 20277 | tt0061135 | 0.140934 | 0 | 0 | The Ugly Dachshund | Dean Jones|Suzanne Pleshette|Charles Ruggles|Kelly Thordsen|Parley Baer | NaN | Norman Tokar | A HAPPY HONEYMOON GOES TO THE DOGS!...When a Great Dane disguised as a Dachsie crashes the party! | great dane|dachshund | The Garrisons (Dean Jones and Suzanne Pleshette) are the "proud parents" of three adorable dachshund pups -- and one overgrown Great Dane named Brutus, who nevertheless thinks of himself as a dainty dachsie. His identity crisis results in an uproarious series of household crises that reduce the Garrisons' house to shambles -- and viewers to howls of laughter! | 93 | Comedy|Drama|Family | Walt Disney Pictures | 2/16/66 | 14 | 5.7 | 1966 | 0.000000 | 0.0 |
| 10857 | 5921 | tt0060748 | 0.131378 | 0 | 0 | Nevada Smith | Steve McQueen|Karl Malden|Brian Keith|Arthur Kennedy|Suzanne Pleshette | NaN | Henry Hathaway | Some called him savage- and some called him saint... some felt his hate- and one found his love... and three had to die... | repayment|revenge|native american|wild west|half breed | Nevada Smith is the young son of an Indian mother and white father. When his father is killed by three men over gold, Nevada sets out to find them and kill them. The boy is taken in by a gun merchant. The gun merchant shows him how to shoot and to shoot on time and correct. | 128 | Action|Western | Paramount Pictures|Solar Productions|Embassy Pictures | 6/10/66 | 10 | 5.9 | 1966 | 0.000000 | 0.0 |
| 10858 | 31918 | tt0060921 | 0.317824 | 0 | 0 | The Russians Are Coming, The Russians Are Coming | Carl Reiner|Eva Marie Saint|Alan Arkin|Brian Keith|Paul Ford | NaN | Norman Jewison | IT'S A PLOT! ...to make the world die laughing!! | cold war|russian|new england | Without hostile intent, a Soviet sub runs aground off New England. Men are sent for a boat, but many villagers go into a tizzy, risking bloodshed. | 126 | Comedy|War | The Mirisch Corporation | 5/25/66 | 11 | 5.5 | 1966 | 0.000000 | 0.0 |
| 10859 | 20620 | tt0060955 | 0.089072 | 0 | 0 | Seconds | Rock Hudson|Salome Jens|John Randolph|Will Geer|Jeff Corey | NaN | John Frankenheimer | NaN | plastic surgery|suspense | A secret organisation offers wealthy people a second chance at life. The customer picks out someone they want to be and the organisation surgically alters the customer to look like the intended person, stages the customer's death, gets rid of the intended person and the customer takes on a new life. | 100 | Mystery|Science Fiction|Thriller|Drama | Gibraltar Productions|Joel Productions|John Frankenheimer Productions Inc. | 10/5/66 | 22 | 6.6 | 1966 | 0.000000 | 0.0 |
| 10860 | 5060 | tt0060214 | 0.087034 | 0 | 0 | Carry On Screaming! | Kenneth Williams|Jim Dale|Harry H. Corbett|Joan Sims|Charles Hawtrey | NaN | Gerald Thomas | Carry On Screaming with the Hilarious CARRY ON Gang!! | monster|carry on|horror spoof | The sinister Dr Watt has an evil scheme going. He's kidnapping beautiful young women and turning them into mannequins to sell to local stores. Fortunately for Dr Watt, Detective-Sergeant Bung is on the case, and he doesn't have a clue! In this send up of the Hammer Horror movies, there are send-ups of all the horror greats from Frankenstein to Dr Jekyl and Mr Hyde. | 87 | Comedy | Peter Rogers Productions|Anglo-Amalgamated Film Distributors | 5/20/66 | 13 | 7.0 | 1966 | 0.000000 | 0.0 |
| 10861 | 21 | tt0060371 | 0.080598 | 0 | 0 | The Endless Summer | Michael Hynson|Robert August|Lord 'Tally Ho' Blears|Bruce Brown|Chip Fitzwater | NaN | Bruce Brown | NaN | surfer|surfboard|surfing | The Endless Summer, by Bruce Brown, is one of the first and most influential surf movies of all times. The film documents American surfers Mike Hynson and Robert August as they travel the world during California’s winter (which back in 1965 was off-season for surfing) in search of the perfect wave and an endless summer. | 95 | Documentary | Bruce Brown Films | 6/15/66 | 11 | 7.4 | 1966 | 0.000000 | 0.0 |
| 10862 | 20379 | tt0060472 | 0.065543 | 0 | 0 | Grand Prix | James Garner|Eva Marie Saint|Yves Montand|ToshirÅ Mifune|Brian Bedford | NaN | John Frankenheimer | Cinerama sweeps YOU into a drama of speed and spectacle! | car race|racing|formula 1 | Grand Prix driver Pete Aron is fired by his team after a crash at Monaco that injures his teammate, Scott Stoddard. While Stoddard struggles to recover, Aron begins to drive for another team, and starts dating Stoddard's wife. | 176 | Action|Adventure|Drama | Cherokee Productions|Joel Productions|Douglas & Lewis Productions | 12/21/66 | 20 | 5.7 | 1966 | 0.000000 | 0.0 |
| 10863 | 39768 | tt0060161 | 0.065141 | 0 | 0 | Beregis Avtomobilya | Innokentiy Smoktunovskiy|Oleg Efremov|Georgi Zhzhyonov|Olga Aroseva|Lyubov Dobrzhanskaya | NaN | Eldar Ryazanov | NaN | car|trolley|stealing car | An insurance agent who moonlights as a carthief steals cars various crooks and never from the common people. He sells the stolen cars and gives the money to charity. His best friend, a cop, is assigned to bring in this modern robin hood. | 94 | Mystery|Comedy | Mosfilm | 1/1/66 | 11 | 6.5 | 1966 | 0.000000 | 0.0 |
| 10864 | 21449 | tt0061177 | 0.064317 | 0 | 0 | What's Up, Tiger Lily? | Tatsuya Mihashi|Akiko Wakabayashi|Mie Hama|John Sebastian|Tadao Nakamaru | NaN | Woody Allen | WOODY ALLEN STRIKES BACK! | spoof | In comic Woody Allen's film debut, he took the Japanese action film "International Secret Police: Key of Keys" and re-dubbed it, changing the plot to make it revolve around a secret egg salad recipe. | 80 | Action|Comedy | Benedict Pictures Corp. | 11/2/66 | 22 | 5.4 | 1966 | 0.000000 | 0.0 |
| 10865 | 22293 | tt0060666 | 0.035919 | 19000 | 0 | Manos: The Hands of Fate | Harold P. Warren|Tom Neyman|John Reynolds|Diane Mahree|Stephanie Nielson | NaN | Harold P. Warren | It's Shocking! It's Beyond Your Imagination! | fire|gun|drive|sacrifice|flashlight | A family gets lost on the road and stumbles upon a hidden, underground, devil-worshiping cult led by the fearsome Master and his servant Torgo. | 74 | Horror | Norm-Iris | 11/15/66 | 15 | 1.5 | 1966 | 127642.279154 | 0.0 |